LibreOffice Calc

 ( Calc : Official Website ) 

LibreOffice Calc is the spreadsheet component of the LibreOffice suite.

After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix many defects in formula calculations involving external references, and to boost data caching performance, especially when referencing large data ranges.

Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets as PDF files.

As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows, and FreeBSD. FreeBSD Handbook, 7.3.5 LibreOffice Available under the Mozilla Public License, Calc is free and open-source software. There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS. LibreOffice Online is an online office suite which includes the applications Writer, Calc and Impress and provides an upstream for projects such as commercial Collabora Online.

There is now a closed beta of LibreOffice on AmigaOS 4.1.

---

Features Capabilities of Calc include:

• Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV, and several other formats.
• Support for many functions, including those for , as well as financial and statistical functions.
• Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets. Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature. Version 7.4 made very large spreadsheets default.
• Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc. were available only in Excel 2016 and later. LibreOffice Calc can use them.

---

Pivot Table Originally called DataPilot, Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.

An advanced sort macro is included that allows data to be arranged or categorised based on either a user generated macro or one of several default included macros.

---

Supported file formats

Apple Numbers	NUMBERS
Comma-separated values	CSV
Data Interchange Format	DIF
DBase, Clipper, VP-Info, FoxPro	DBF
Gnumeric	GNM, GNUMERIC
Lotus 1-2-3	123, WKS, WKS1, WK2, WK3, WK4
Microsoft Excel 4/5/95	XLS, XLW, XLT	, writing up to 3.6
Microsoft Excel 97–2003	XLS, XLW, XLT
Microsoft Excel 2007–2021	XLSX, XLTX, XLSM, XLTM
Microsoft Excel 2003 XML	XML
Microsoft Excel Web Query File	IQY
Microsoft Pocket Excel	PXL		Requires Java
OpenDocument (spreadsheet)	ODS, FODS, OTS,
OpenOffice.org XML (spreadsheet)	SXC, STC
Quattro Pro 6.0	WB2, WQ1, WQ2
StarOffice StarCalc 3/4/5	SDC, VOR
SYLK	SLK

---

See also

• LibreOffice Writer
• List of spreadsheet software
• Comparison of spreadsheet software

---

External links

Categories: Calc : Official Website, Cross-platform Free Software, Free Spreadsheet Software, Calc, Spreadsheet Software, Spreadsheet Software For Macos, Spreadsheet Software For Windows, Software Using The Gnu General Public License

Post Comment